报错信息： Import: Release 11.2.0.4.0 - Production on Wed Dec 7 17:59:59 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_TABLE_03": "/******** AS SYSDBA" directory=impdp_asm_dir dumpfile= TERMINALACTIVELOGS_20200115.dmp logfile=impdp_log_dir:TERMINALACTIVELOGS_20200115.log tables=COM.TERMINALACTIVELOGS_20200115 cluster=n r Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "COM"." TERMINALACTIVELOGS_20200115" 28.89 GB 139222130 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT ORA-39083: Object type OBJECT_GRANT failed to create with error: ORA-01917: user or role 'GAB_XPLBD' does not exist Failing sql is: GRANT SELECT ON "COM"." TERMINALACTIVELOGS_20200115" TO "GAB_XPLBD" Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX 解决方案 既然导入的时候报错了，说明源数据库中是存在该对象的，那么首先要做的是，去源库中查询该角色的权限信息，然后在新的数据库中，在sys用户下，建一个角色 GAB_XPLBD，并赋给和源数据库中相同的数据库操作权限，然后再重新执行导入操作。